package com.ws.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ws.entity.Address;
import org.apache.ibatis.annotations.Select;

public interface AddressMapper extends BaseMapper<Address> {

    @Select("select      " +
            "id,      " +
            "address,      " +
            "province,      " +
            "province_id,      " +
            "user_id,      " +
            "city,      " +
            "city_id,      " +
            "area,      " +
            "area_id,      " +
            "`name`,      " +
            "phone,      " +
            "is_default,      " +
            "post_code      " +
            "from shop_address")
    Page<Address> getAddressListForPage(Page<Address> page);
}
